121. Report with Output Database Updating – Wait Record Locking for Update Database Datafile Software Report with Output Database Updating – Wait Record Locking for Update Database The option ‘Report with Output Database Updating’, more commonly referred to as the ‘Sort & Slot Report’ exclusively l... Read More
122. T-Table Description as Data Item Datafile Software T-Table Description as Data Item When showing table items on screen the system shows the value followed by the text description associated with it. When showing on reports / documents then generally only the value is shown, sim... Read More
123. Extra 160 Items per Database Datafile Software Extra 160 Items per Database From Release 5.9 each database in the system will allow up to 320 data items – doubling the existing availability of 160. No specific changes are required to enable these items other than the stan... Read More
124. Output to Excel Pivot Table Datafile Software Output to Excel Pivot Table One of the more useful tools within Excel is the Pivot Table utility. The pivot table is a data summarization tool and among other functions, they can automatically sort, count, and total the data st... Read More
125. Database Activity Alerts Datafile Software Database Activity Alerts This new accessory, available as a trial in Release 6.2, allows the system to create/send emails when, for example, an account is placed on stop or goes over its credit limit. The Alerts option also all... Read More
126. Output to Pivot Tables - Accept and Save Options Datafile Software Output to Pivot Tables - Accept and Save Options Release 6.0 introduced the reporting option to output data to an Excel Pivot Table. Following feedback from users the run-time parameters now allow an ACCEPT and a SAVE option, t... Read More
127. History Database Cross-Links Datafile Software History Database Cross-Links The Datafile Premier system allows extra detail databases, termed ‘History’ files, to be viewed off the Sales Ledger, Purchase Ledger, Sales Order and Purchase Order Ledger Enquiry optio... Read More
128. Print Database Structure Datafile Software Print Database Structure During system maintenance it can be useful tool to print the database structure which details the data item names and types within the system. Where Table Items and Constant Values (both as an item type... Read More
129. SQLDET Database Structure Datafile Software SQLDET Database Structure Two new data items can be added to the SQLDET.DFD file that will record the program and the parameter number which generated, together with the existing (Premier only) options to record the user-id, da... Read More
130. Database Refresh - Empty Table and Re-Import Data Datafile Software Database Refresh - Empty Table and Re-Import Data Release 6.4 introduces several additional processing options for mirroring a Datafile Database to an SQL table when the SQL Driver has been purchased.  Against each Datafile... Read More